package orz.itrip.mapper;

import org.apache.ibatis.annotations.Select;
import orz.itrip.pojo.HotelTempStore;
import orz.itrip.vo.PreFlushStoreVo;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface HotelTempStoreMapper extends Mapper<HotelTempStore> {
    @Select("SELECT * FROM itrip_hotel_temp_store WHERE hotelId=#{hotelId1} AND roomId=#{roomId1} AND TO_DAYS(recordDate) BETWEEN TO_DAYS(#{startTime}) AND TO_DAYS(#{endTime})")
    List<HotelTempStore> selectHotelTempScore(PreFlushStoreVo preFlushStoreVo);
}